| Column | Data Type | Nullable | Default | Description |
| ShoppingCartItemID | int | not null | | Primary key for ShoppingCartItem records. |
| ShoppingCartID | nvarchar(50) | not null | | Shopping cart identification number. |
| Quantity | int | not null | ((1)) | Product quantity ordered. |
| ProductID | int | not null | | Product ordered. Foreign key to Product.ProductID. |
| DateCreated | datetime | not null | (getdate()) | Date the time the record was created. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |